Группировка с выбором 1 наибольшего в каждой группе | GROUP BY
Редактировал(а) Alexandr Fokin 2023/12/16 14:12
SELECT
t1.GroupItem,
t1.SortProperty
FROM
dbo.Table1 t1
JOIN (
SELECT
t1.GroupItem,
max(t1.SortProperty) AS MaxSortValue
FROM
dbo.Table1 t1
GROUP BY
t1.GroupItem
) AS dt ON t1.GroupItem = dt.GroupItem
--AND t1.SortProperty = dt.MaxSortValue
t1.GroupItem,
t1.SortProperty
FROM
dbo.Table1 t1
JOIN (
SELECT
t1.GroupItem,
max(t1.SortProperty) AS MaxSortValue
FROM
dbo.Table1 t1
GROUP BY
t1.GroupItem
) AS dt ON t1.GroupItem = dt.GroupItem
--AND t1.SortProperty = dt.MaxSortValue